Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	392735
Missing cells	320070
Missing cells (%)	4.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	187.0 MiB
Average record size in memory	499.2 B

Variable types

Categorical	4
Numeric	10
Boolean	3

Alerts

`OriginalCreditor_Redacted` has a high cardinality: 52 distinct values	High cardinality
`CurrentBalance` is highly overall correlated with `DebtLoadPrincipal` and 1 other fields	High correlation
`DebtLoadPrincipal` is highly overall correlated with `CurrentBalance` and 1 other fields	High correlation
`BalanceAtDebtLoad` is highly overall correlated with `CurrentBalance` and 1 other fields	High correlation
`PurchasePrice` is highly overall correlated with `FrequencyEncodedCreditor` and 1 other fields	High correlation
`NumPhones` is highly overall correlated with `IsStatBarred`	High correlation
`FrequencyEncodedCreditor` is highly overall correlated with `PurchasePrice` and 2 other fields	High correlation
`OriginalCreditor_Redacted` is highly overall correlated with `PurchasePrice` and 2 other fields	High correlation
`ProductOrDebtType` is highly overall correlated with `FrequencyEncodedCreditor` and 1 other fields	High correlation
`CollectionStatus` is highly overall correlated with `IsStatBarred` and 1 other fields	High correlation
`IsStatBarred` is highly overall correlated with `NumPhones` and 1 other fields	High correlation
`IsLegal` is highly overall correlated with `CollectionStatus`	High correlation
`InBankruptcy` is highly imbalanced (85.4%)	Imbalance
`IsLegal` is highly imbalanced (83.3%)	Imbalance
`NumLiableParties` is highly imbalanced (93.6%)	Imbalance
`LastPaymentAmount` has 290802 (74.0%) missing values	Missing
`CustomerAge` has 26490 (6.7%) missing values	Missing
`CurrentBalance` is highly skewed (γ1 = 26.66167707)	Skewed
`DebtLoadPrincipal` is highly skewed (γ1 = 37.04147046)	Skewed
`BalanceAtDebtLoad` is highly skewed (γ1 = 34.7372639)	Skewed
`CurrentBalance` has 68045 (17.3%) zeros	Zeros
`NumPhones` has 266389 (67.8%) zeros	Zeros
`NumEmails` has 312660 (79.6%) zeros	Zeros
`NumAddresses` has 76185 (19.4%) zeros	Zeros

Reproduction

Analysis started	2023-10-17 05:40:39.698113
Analysis finished	2023-10-17 05:41:15.050069
Duration	35.35 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

OriginalCreditor_Redacted
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	28.4 MiB

Creditor 17	82764
Creditor 47	54845
Creditor 33	52340
Creditor 48	24854
Creditor 19	20454
Other values (47)	157478

Length

Max length	11
Median length	11
Mean length	10.939399
Min length	10

Characters and Unicode

Total characters	4296285
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Creditor 1
2nd row	Creditor 2
3rd row	Creditor 1
4th row	Creditor 2
5th row	Creditor 1

Common Values

Value	Count	Frequency (%)
Creditor 17	82764	21.1%
Creditor 47	54845	14.0%
Creditor 33	52340	13.3%
Creditor 48	24854	6.3%
Creditor 19	20454	5.2%
Creditor 10	18922	4.8%
Creditor 44	17242	4.4%
Creditor 25	16443	4.2%
Creditor 42	15933	4.1%
Creditor 35	14474	3.7%
Other values (42)	74464	19.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
creditor	392735	50.0%
17	82764	10.5%
47	54845	7.0%
33	52340	6.7%
48	24854	3.2%
19	20454	2.6%
10	18922	2.4%
44	17242	2.2%
25	16443	2.1%
42	15933	2.0%
Other values (43)	88938	11.3%

Most occurring characters

Value	Count	Frequency (%)
r	785470	18.3%
C	392735	9.1%
e	392735	9.1%
d	392735	9.1%
i	392735	9.1%
t	392735	9.1%
o	392735	9.1%
	392735	9.1%
4	151858	3.5%
7	151524	3.5%
Other values (8)	458288	10.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2749145	64.0%
Decimal Number	761670	17.7%
Uppercase Letter	392735	9.1%
Space Separator	392735	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	151858	19.9%
7	151524	19.9%
3	137973	18.1%
1	128565	16.9%
5	48663	6.4%
2	38353	5.0%
0	36058	4.7%
8	33075	4.3%
9	29700	3.9%
6	5901	0.8%

Lowercase Letter

Value	Count	Frequency (%)
r	785470	28.6%
e	392735	14.3%
d	392735	14.3%
i	392735	14.3%
t	392735	14.3%
o	392735	14.3%

Uppercase Letter

Value	Count	Frequency (%)
C	392735	100.0%

Space Separator

Value	Count	Frequency (%)
	392735	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3141880	73.1%
Common	1154405	26.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
	392735	34.0%
4	151858	13.2%
7	151524	13.1%
3	137973	12.0%
1	128565	11.1%
5	48663	4.2%
2	38353	3.3%
0	36058	3.1%
8	33075	2.9%
9	29700	2.6%

Latin

Value	Count	Frequency (%)
r	785470	25.0%
C	392735	12.5%
e	392735	12.5%
d	392735	12.5%
i	392735	12.5%
t	392735	12.5%
o	392735	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4296285	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	785470	18.3%
C	392735	9.1%
e	392735	9.1%
d	392735	9.1%
i	392735	9.1%
t	392735	9.1%
o	392735	9.1%
	392735	9.1%
4	151858	3.5%
7	151524	3.5%
Other values (8)	458288	10.7%

CurrentBalance
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	177653
Distinct (%)	45.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1342.9503

Minimum	-7717.2
Maximum	441681.52
Zeros	68045
Zeros (%)	17.3%
Negative	2717
Negative (%)	0.7%
Memory size	6.0 MiB

Quantile statistics

Minimum	-7717.2
5-th percentile	0
Q1	106.665
median	486.89
Q3	1204.77
95-th percentile	5387.97
Maximum	441681.52
Range	449398.72
Interquartile range (IQR)	1098.105

Descriptive statistics

Standard deviation	4093.788
Coefficient of variation (CV)	3.048354
Kurtosis	1578.4783
Mean	1342.9503
Median Absolute Deviation (MAD)	464.02
Skewness	26.661677
Sum	5.274236 × 10⁸
Variance	16759100
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	68045	17.3%
50	172	< 0.1%
30	156	< 0.1%
65.63	134	< 0.1%
40.68	130	< 0.1%
60	130	< 0.1%
32.35	124	< 0.1%
20	123	< 0.1%
45.29	122	< 0.1%
59.38	118	< 0.1%
Other values (177643)	323481	82.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-7717.2	1	< 0.1%
-7436.41	1	< 0.1%
-6613.66	1	< 0.1%
-5230.35	1	< 0.1%
-4928.52	1	< 0.1%
-4920.03	1	< 0.1%
-4701.68	1	< 0.1%
-4655.43	1	< 0.1%
-4479.42	1	< 0.1%
-4388.03	1	< 0.1%

Value	Count	Frequency (%)
441681.52	1	< 0.1%
425064.21	1	< 0.1%
384946.87	1	< 0.1%
315137.08	1	< 0.1%
293571.08	1	< 0.1%
286287.29	1	< 0.1%
285475.44	1	< 0.1%
261650.56	1	< 0.1%
239452.19	1	< 0.1%
226832.93	1	< 0.1%

DebtLoadPrincipal
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	195921
Distinct (%)	49.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1588.3375

Minimum	0
Maximum	844343
Zeros	152
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	51
Q1	272.86
median	647.84
Q3	1444.54
95-th percentile	5945.136
Maximum	844343
Range	844343
Interquartile range (IQR)	1171.68

Descriptive statistics

Standard deviation	4484.2173
Coefficient of variation (CV)	2.8232145
Kurtosis	4158.01
Mean	1588.3375
Median Absolute Deviation (MAD)	457.71
Skewness	37.04147
Sum	6.2379572 × 10⁸
Variance	20108205
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	1103	0.3%
25	1100	0.3%
47	725	0.2%
45	631	0.2%
20	605	0.2%
30	557	0.1%
27	524	0.1%
40	433	0.1%
36	431	0.1%
60	410	0.1%
Other values (195911)	386216	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	152	< 0.1%
0.01	10	< 0.1%
0.02	2	< 0.1%
0.03	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.09	1	< 0.1%
0.11	2	< 0.1%
0.16	1	< 0.1%
0.21	2	< 0.1%

Value	Count	Frequency (%)
844343	1	< 0.1%
425064.21	1	< 0.1%
384946.87	1	< 0.1%
383878.71	1	< 0.1%
293571.08	1	< 0.1%
286287.29	1	< 0.1%
285475.44	1	< 0.1%
274006.16	1	< 0.1%
261650.56	1	< 0.1%
245937.19	1	< 0.1%

BalanceAtDebtLoad
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	198413
Distinct (%)	50.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1652.2256

Minimum	0
Maximum	844343
Zeros	122
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	56.16
Q1	276.225
median	661.02
Q3	1487.53
95-th percentile	6227.55
Maximum	844343
Range	844343
Interquartile range (IQR)	1211.305

Descriptive statistics

Standard deviation	4601.4435
Coefficient of variation (CV)	2.7849971
Kurtosis	3756.8049
Mean	1652.2256
Median Absolute Deviation (MAD)	468.52
Skewness	34.737264
Sum	6.4888683 × 10⁸
Variance	21173282
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.68	394	0.1%
45.29	391	0.1%
32.35	358	0.1%
30	357	0.1%
39.3	331	0.1%
62.94	330	0.1%
65.63	329	0.1%
50	303	0.1%
59.38	291	0.1%
90.63	287	0.1%
Other values (198403)	389364	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	122	< 0.1%
0.01	10	< 0.1%
0.02	2	< 0.1%
0.03	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.09	1	< 0.1%
0.11	2	< 0.1%
0.16	1	< 0.1%
0.21	2	< 0.1%

Value	Count	Frequency (%)
844343	1	< 0.1%
425064.21	1	< 0.1%
384946.87	1	< 0.1%
383878.71	1	< 0.1%
293571.08	1	< 0.1%
286287.29	1	< 0.1%
285475.44	1	< 0.1%
274006.16	1	< 0.1%
261650.56	1	< 0.1%
245937.19	1	< 0.1%

PurchasePrice
Real number (ℝ)

Distinct	48
Distinct (%)	< 0.1%
Missing	2656
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	5.6738133

Minimum	0.19
Maximum	52.18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	0.19
5-th percentile	2.32
Q1	3.07
median	4.22
Q3	6.59
95-th percentile	11.7
Maximum	52.18
Range	51.99
Interquartile range (IQR)	3.52

Descriptive statistics

Standard deviation	5.5238955
Coefficient of variation (CV)	0.97357725
Kurtosis	46.780741
Mean	5.6738133
Median Absolute Deviation (MAD)	1.15
Skewness	6.0923307
Sum	2213235.4
Variance	30.513421
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
3.07	82760	21.1%
2.32	39859	10.1%
3.6	35115	8.9%
7.38	34213	8.7%
5.72	24854	6.3%
4.22	24035	6.1%
4.96	18865	4.8%
6.59	17224	4.4%
4.31	16575	4.2%
11.7	16435	4.2%
Other values (38)	80144	20.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.19	853	0.2%
0.65	310	0.1%
1.44	1325	0.3%
1.77	355	0.1%
1.84	2762	0.7%
2.32	39859	10.1%
2.35	106	< 0.1%
3.07	82760	21.1%
3.6	35115	8.9%
3.87	8449	2.2%

Value	Count	Frequency (%)
52.18	3782	1.0%
32.27	246	0.1%
25.41	1158	0.3%
16.7	434	0.1%
15.31	3521	0.9%
15	1	< 0.1%
14.83	1542	0.4%
12	3	< 0.1%
11.73	1	< 0.1%
11.71	2	< 0.1%

ProductOrDebtType
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	31.1 MiB

Utilities/Telco - Other	207110
Other	75586
Finance Company - Other	48693
Store Cards	17699
Credit Cards	16885
Other values (5)	26762

Length

Max length	23
Median length	23
Mean length	17.988575
Min length	5

Characters and Unicode

Total characters	7064743
Distinct characters	32
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Other
2nd row	Other
3rd row	Other
4th row	Other
5th row	Other

Common Values

Value	Count	Frequency (%)
Utilities/Telco - Other	207110	52.7%
Other	75586	19.2%
Finance Company - Other	48693	12.4%
Store Cards	17699	4.5%
Credit Cards	16885	4.3%
Bank - Other	13030	3.3%
Residential Electricity	7693	2.0%
Personal Loans	4309	1.1%
Loans	1260	0.3%
Hire Purchase	470	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
other	344419	33.6%
	268833	26.2%
utilities/telco	207110	20.2%
finance	48693	4.7%
company	48693	4.7%
cards	34584	3.4%
store	17699	1.7%
credit	16885	1.6%
bank	13030	1.3%
residential	7693	0.7%
Other values (5)	18511	1.8%

Most occurring characters

Value	Count	Frequency (%)
e	870244	12.3%
t	816302	11.6%
i	718150	10.2%
	633415	9.0%
l	433915	6.1%
r	426529	6.0%
h	344889	4.9%
O	344419	4.9%
o	283380	4.0%
c	271659	3.8%
Other values (22)	1921841	27.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4990958	70.6%
Uppercase Letter	964427	13.7%
Space Separator	633415	9.0%
Dash Punctuation	268833	3.8%
Other Punctuation	207110	2.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	870244	17.4%
t	816302	16.4%
i	718150	14.4%
l	433915	8.7%
r	426529	8.5%
h	344889	6.9%
o	283380	5.7%
c	271659	5.4%
s	259735	5.2%
n	176680	3.5%
Other values (7)	389475	7.8%

Uppercase Letter

Value	Count	Frequency (%)
O	344419	35.7%
U	207110	21.5%
T	207110	21.5%
C	100162	10.4%
F	48693	5.0%
S	17699	1.8%
B	13030	1.4%
R	7693	0.8%
E	7693	0.8%
L	5569	0.6%
Other values (2)	5249	0.5%

Space Separator

Value	Count	Frequency (%)
	633415	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	268833	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	207110	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5955385	84.3%
Common	1109358	15.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	870244	14.6%
t	816302	13.7%
i	718150	12.1%
l	433915	7.3%
r	426529	7.2%
h	344889	5.8%
O	344419	5.8%
o	283380	4.8%
c	271659	4.6%
s	259735	4.4%
Other values (19)	1186163	19.9%

Common

Value	Count	Frequency (%)
	633415	57.1%
-	268833	24.2%
/	207110	18.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7064743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	870244	12.3%
t	816302	11.6%
i	718150	10.2%
	633415	9.0%
l	433915	6.1%
r	426529	6.0%
h	344889	4.9%
O	344419	4.9%
o	283380	4.0%
c	271659	3.8%
Other values (22)	1921841	27.2%

CollectionStatus
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	27.3 MiB

ACTIVE	167445
PASSIVE	128651
PAID_IN_FULL	67043
CLOSED	13524
CANCELLED_WITHDRAWN	5401
Other values (7)	10671

Length

Max length	19
Median length	17
Mean length	7.7671789
Min length	5

Characters and Unicode

Total characters	3050443
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PAID_IN_FULL
2nd row	CANCELLED_WITHDRAWN
3rd row	PAID_IN_FULL
4th row	PASSIVE
5th row	PAID_IN_FULL

Common Values

Value	Count	Frequency (%)
ACTIVE	167445	42.6%
PASSIVE	128651	32.8%
PAID_IN_FULL	67043	17.1%
CLOSED	13524	3.4%
CANCELLED_WITHDRAWN	5401	1.4%
UNDER_ARRANGEMENT	4237	1.1%
SETTLED FOR LESS	4191	1.1%
LEGAL	1559	0.4%
LEGAL_ARRANGEMENT	361	0.1%
NON_COLLECTION	237	0.1%
Other values (2)	86	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
active	167445	41.7%
passive	128651	32.1%
paid_in_full	67043	16.7%
closed	13524	3.4%
cancelled_withdrawn	5401	1.3%
under_arrangement	4237	1.1%
settled	4191	1.0%
for	4191	1.0%
less	4191	1.0%
legal	1559	0.4%
Other values (4)	684	0.2%

Most occurring characters

Value	Count	Frequency (%)
I	435906	14.3%
A	385057	12.6%
E	348612	11.4%
V	296096	9.7%
S	283399	9.3%
P	195721	6.4%
C	192245	6.3%
T	186063	6.1%
L	171167	5.6%
_	144322	4.7%
Other values (11)	411855	13.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2897739	95.0%
Connector Punctuation	144322	4.7%
Space Separator	8382	0.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	435906	15.0%
A	385057	13.3%
E	348612	12.0%
V	296096	10.2%
S	283399	9.8%
P	195721	6.8%
C	192245	6.6%
T	186063	6.4%
L	171167	5.9%
D	99883	3.4%
Other values (9)	303590	10.5%

Connector Punctuation

Value	Count	Frequency (%)
_	144322	100.0%

Space Separator

Value	Count	Frequency (%)
	8382	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2897739	95.0%
Common	152704	5.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	435906	15.0%
A	385057	13.3%
E	348612	12.0%
V	296096	10.2%
S	283399	9.8%
P	195721	6.8%
C	192245	6.6%
T	186063	6.4%
L	171167	5.9%
D	99883	3.4%
Other values (9)	303590	10.5%

Common

Value	Count	Frequency (%)
_	144322	94.5%
	8382	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3050443	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	435906	14.3%
A	385057	12.6%
E	348612	11.4%
V	296096	9.7%
S	283399	9.3%
P	195721	6.4%
C	192245	6.3%
T	186063	6.1%
L	171167	5.6%
_	144322	4.7%
Other values (11)	411855	13.5%

IsStatBarred
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

True	273082
False	119653

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	273082	69.5%
False	119653	30.5%

InBankruptcy
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

False	384586
True	8149

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	384586	97.9%
True	8149	2.1%

IsLegal
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

False	383021
True	9714

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	383021	97.5%
True	9714	2.5%

LastPaymentAmount
Real number (ℝ)

Distinct	25874
Distinct (%)	25.4%
Missing	290802
Missing (%)	74.0%
Infinite	0
Infinite (%)	0.0%
Mean	288.86777

Minimum	0.01
Maximum	73131.84
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	0.01
5-th percentile	5.386
Q1	20
median	40
Q3	148.68
95-th percentile	1199.814
Maximum	73131.84
Range	73131.83
Interquartile range (IQR)	128.68

Descriptive statistics

Standard deviation	1130.4537
Coefficient of variation (CV)	3.9133951
Kurtosis	459.8578
Mean	288.86777
Median Absolute Deviation (MAD)	30
Skewness	15.40208
Sum	29445158
Variance	1277925.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	9750	2.5%
10	7538	1.9%
50	4545	1.2%
30	3612	0.9%
25	3067	0.8%
40	2949	0.8%
5	2611	0.7%
100	2128	0.5%
15	2084	0.5%
60	1123	0.3%
Other values (25864)	62526	15.9%
(Missing)	290802	74.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	24	< 0.1%
0.02	9	< 0.1%
0.03	5	< 0.1%
0.04	8	< 0.1%
0.05	8	< 0.1%
0.06	4	< 0.1%
0.07	1	< 0.1%
0.08	3	< 0.1%
0.09	3	< 0.1%
0.1	11	< 0.1%

Value	Count	Frequency (%)
73131.84	1	< 0.1%
48521.79	1	< 0.1%
45105.92	1	< 0.1%
45000	1	< 0.1%
44000	1	< 0.1%
43500	1	< 0.1%
40000	1	< 0.1%
36100	1	< 0.1%
36000	1	< 0.1%
35521.72	1	< 0.1%

NumLiableParties
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	122
Missing (%)	< 0.1%
Memory size	25.5 MiB

1.0	385808
2.0	6650
3.0	151
4.0	4

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1177839
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	385808	98.2%
2.0	6650	1.7%
3.0	151	< 0.1%
4.0	4	< 0.1%
(Missing)	122	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	385808	98.3%
2.0	6650	1.7%
3.0	151	< 0.1%
4.0	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	392613	33.3%
0	392613	33.3%
1	385808	32.8%
2	6650	0.6%
3	151	< 0.1%
4	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	785226	66.7%
Other Punctuation	392613	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	392613	50.0%
1	385808	49.1%
2	6650	0.8%
3	151	< 0.1%
4	4	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	392613	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1177839	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	392613	33.3%
0	392613	33.3%
1	385808	32.8%
2	6650	0.6%
3	151	< 0.1%
4	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1177839	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	392613	33.3%
0	392613	33.3%
1	385808	32.8%
2	6650	0.6%
3	151	< 0.1%
4	4	< 0.1%

CustomerAge
Real number (ℝ)

Distinct	126
Distinct (%)	< 0.1%
Missing	26490
Missing (%)	6.7%
Infinite	0
Infinite (%)	0.0%
Mean	45.938066

Minimum	-41
Maximum	133
Zeros	0
Zeros (%)	0.0%
Negative	20
Negative (%)	< 0.1%
Memory size	6.0 MiB

Quantile statistics

Minimum	-41
5-th percentile	29
Q1	36
median	44
Q3	54
95-th percentile	70
Maximum	133
Range	174
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	12.862101
Coefficient of variation (CV)	0.27998787
Kurtosis	0.65817338
Mean	45.938066
Median Absolute Deviation (MAD)	9
Skewness	0.78275274
Sum	16824587
Variance	165.43365
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38	13936	3.5%
37	13488	3.4%
39	13027	3.3%
36	12532	3.2%
40	12353	3.1%
41	12015	3.1%
35	11286	2.9%
42	11282	2.9%
34	10880	2.8%
43	10654	2.7%
Other values (116)	244792	62.3%
(Missing)	26490	6.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-41	1	< 0.1%
-31	3	< 0.1%
-30	1	< 0.1%
-29	1	< 0.1%
-28	5	< 0.1%
-22	1	< 0.1%
-20	2	< 0.1%
-6	1	< 0.1%
-4	1	< 0.1%
-3	4	< 0.1%

Value	Count	Frequency (%)
133	2	< 0.1%
132	1	< 0.1%
121	4	< 0.1%
120	12	< 0.1%
119	1	< 0.1%
115	1	< 0.1%
114	2	< 0.1%
113	3	< 0.1%
112	2	< 0.1%
111	10	< 0.1%

NumPhones
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.43395929

Minimum	0
Maximum	8
Zeros	266389
Zeros (%)	67.8%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.71857973
Coefficient of variation (CV)	1.655869
Kurtosis	3.190096
Mean	0.43395929
Median Absolute Deviation (MAD)	0
Skewness	1.759986
Sum	170431
Variance	0.51635683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	266389	67.8%
1	90147	23.0%
2	29282	7.5%
3	6131	1.6%
4	633	0.2%
5	128	< 0.1%
6	22	< 0.1%
8	2	< 0.1%
7	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	266389	67.8%
1	90147	23.0%
2	29282	7.5%
3	6131	1.6%
4	633	0.2%
5	128	< 0.1%
6	22	< 0.1%
7	1	< 0.1%
8	2	< 0.1%

Value	Count	Frequency (%)
8	2	< 0.1%
7	1	< 0.1%
6	22	< 0.1%
5	128	< 0.1%
4	633	0.2%
3	6131	1.6%
2	29282	7.5%
1	90147	23.0%
0	266389	67.8%

NumEmails
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21530039

Minimum	0
Maximum	5
Zeros	312660
Zeros (%)	79.6%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.44001087
Coefficient of variation (CV)	2.0437068
Kurtosis	3.2364063
Mean	0.21530039
Median Absolute Deviation (MAD)	0
Skewness	1.8833761
Sum	84556
Variance	0.19360957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	312660	79.6%
1	75917	19.3%
2	3870	1.0%
3	257	0.1%
4	27	< 0.1%
5	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	312660	79.6%
1	75917	19.3%
2	3870	1.0%
3	257	0.1%
4	27	< 0.1%
5	4	< 0.1%

Value	Count	Frequency (%)
5	4	< 0.1%
4	27	< 0.1%
3	257	0.1%
2	3870	1.0%
1	75917	19.3%
0	312660	79.6%

NumAddresses
Real number (ℝ)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.84391765

Minimum	0
Maximum	7
Zeros	76185
Zeros (%)	19.4%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.46529122
Coefficient of variation (CV)	0.55134671
Kurtosis	3.0576544
Mean	0.84391765
Median Absolute Deviation (MAD)	0
Skewness	-0.19020604
Sum	331436
Variance	0.21649592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	303168	77.2%
0	76185	19.4%
2	12086	3.1%
3	1127	0.3%
4	139	< 0.1%
5	22	< 0.1%
6	7	< 0.1%
7	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	76185	19.4%
1	303168	77.2%
2	12086	3.1%
3	1127	0.3%
4	139	< 0.1%
5	22	< 0.1%
6	7	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
6	7	< 0.1%
5	22	< 0.1%
4	139	< 0.1%
3	1127	0.3%
2	12086	3.1%
1	303168	77.2%
0	76185	19.4%

FrequencyEncodedCreditor
Real number (ℝ)

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10031669

Minimum	2.4604907 × 10^-6
Maximum	0.20857087
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	2.4604907 × 10^-6
5-th percentile	0.0058239814
Q1	0.040999156
median	0.061172719
Q3	0.13612911
95-th percentile	0.20857087
Maximum	0.20857087
Range	0.20856841
Interquartile range (IQR)	0.095129951

Descriptive statistics

Standard deviation	0.070767034
Coefficient of variation (CV)	0.70543626
Kurtosis	-1.3325713
Mean	0.10031669
Median Absolute Deviation (MAD)	0.05902225
Skewness	0.33599867
Sum	39397.877
Variance	0.0050079731
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2085708732	82764	21.1%
0.1350686354	54845	14.0%
0.1361291069	52340	13.3%
0.06117271906	24854	6.3%
0.05032687619	20454	5.2%
0.04659431184	18922	4.8%
0.04242378015	17242	4.4%
0.04099915605	16443	4.2%
0.03920545835	15933	4.1%
0.03562790492	14474	3.7%
Other values (40)	74464	19.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.460490671 × 10^-6	3	< 0.1%
4.920981342 × 10^-6	2	< 0.1%
9.841962684 × 10^-6	4	< 0.1%
1.476294403 × 10^-5	6	< 0.1%
1.968392537 × 10^-5	8	< 0.1%
3.198637872 × 10^-5	13	< 0.1%
7.381472013 × 10^-5	30	< 0.1%
0.0001451689496	59	< 0.1%
0.0001919182723	78	< 0.1%
0.000201760235	82	< 0.1%

Value	Count	Frequency (%)
0.2085708732	82764	21.1%
0.1361291069	52340	13.3%
0.1350686354	54845	14.0%
0.06117271906	24854	6.3%
0.05438176481	13750	3.5%
0.05032687619	20454	5.2%
0.04659431184	18922	4.8%
0.04242378015	17242	4.4%
0.04099915605	16443	4.2%
0.03920545835	15933	4.1%

Auto

Heatmap
Table

	CurrentBalance	DebtLoadPrincipal	BalanceAtDebtLoad	PurchasePrice	LastPaymentAmount	CustomerAge	NumPhones	NumEmails	NumAddresses	FrequencyEncodedCreditor	OriginalCreditor_Redacted	ProductOrDebtType	CollectionStatus	IsStatBarred	InBankruptcy	IsLegal	NumLiableParties
CurrentBalance	1.000	0.679	0.672	0.169	-0.273	-0.088	-0.290	-0.002	-0.206	-0.236	0.046	0.036	0.017	0.004	0.041	0.034	0.056
DebtLoadPrincipal	0.679	1.000	0.999	0.379	0.111	-0.084	0.102	0.246	-0.103	-0.461	0.051	0.037	0.007	0.000	0.018	0.000	0.048
BalanceAtDebtLoad	0.672	0.999	1.000	0.386	0.114	-0.082	0.108	0.243	-0.103	-0.472	0.050	0.037	0.007	0.000	0.018	0.000	0.048
PurchasePrice	0.169	0.379	0.386	1.000	0.050	-0.116	0.207	0.283	-0.048	-0.659	0.841	0.329	0.178	0.205	0.048	0.229	0.037
LastPaymentAmount	-0.273	0.111	0.114	0.050	1.000	0.016	0.153	0.094	0.063	-0.047	0.046	0.040	0.028	0.025	0.010	0.077	0.023
CustomerAge	-0.088	-0.084	-0.082	-0.116	0.016	1.000	-0.050	-0.196	0.062	0.117	0.131	0.078	0.068	0.121	0.016	0.030	0.015
NumPhones	-0.290	0.102	0.108	0.207	0.153	-0.050	1.000	0.376	0.150	-0.276	0.159	0.125	0.206	0.564	0.106	0.100	0.121
NumEmails	-0.002	0.246	0.243	0.283	0.094	-0.196	0.376	1.000	0.048	-0.291	0.234	0.209	0.168	0.413	0.043	0.072	0.128
NumAddresses	-0.206	-0.103	-0.103	-0.048	0.063	0.062	0.150	0.048	1.000	0.102	0.153	0.097	0.126	0.163	0.092	0.039	0.224
FrequencyEncodedCreditor	-0.236	-0.461	-0.472	-0.659	-0.047	0.117	-0.276	-0.291	0.102	1.000	1.000	0.530	0.308	0.253	0.056	0.168	0.055
OriginalCreditor_Redacted	0.046	0.051	0.050	0.841	0.046	0.131	0.159	0.234	0.153	1.000	1.000	0.789	0.274	0.473	0.106	0.350	0.204
ProductOrDebtType	0.036	0.037	0.037	0.329	0.040	0.078	0.125	0.209	0.097	0.530	0.789	1.000	0.175	0.481	0.068	0.193	0.073
CollectionStatus	0.017	0.007	0.007	0.178	0.028	0.068	0.206	0.168	0.126	0.308	0.274	0.175	1.000	0.794	0.478	0.537	0.049
IsStatBarred	0.004	0.000	0.000	0.205	0.025	0.121	0.564	0.413	0.163	0.253	0.473	0.481	0.794	1.000	0.104	0.080	0.049
InBankruptcy	0.041	0.018	0.018	0.048	0.010	0.016	0.106	0.043	0.092	0.056	0.106	0.068	0.478	0.104	1.000	0.019	0.007
IsLegal	0.034	0.000	0.000	0.229	0.077	0.030	0.100	0.072	0.039	0.168	0.350	0.193	0.537	0.080	0.019	1.000	0.046
NumLiableParties	0.056	0.048	0.048	0.037	0.023	0.015	0.121	0.128	0.224	0.055	0.204	0.073	0.049	0.049	0.007	0.046	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	OriginalCreditor_Redacted	CurrentBalance	DebtLoadPrincipal	BalanceAtDebtLoad	PurchasePrice	ProductOrDebtType	CollectionStatus	IsStatBarred	InBankruptcy	IsLegal	LastPaymentAmount	NumLiableParties	CustomerAge	NumPhones	NumAddresses	FrequencyEncodedCreditor
0	Creditor 1	0.00	1160.20	1160.20	4.22	Other	PAID_IN_FULL	N	N	Y	10.00	1.0	53.0	0	1	0.000020
1	Creditor 2	182.90	182.90	182.90	4.22	Other	CANCELLED_WITHDRAWN	Y	N	N	NaN	1.0	NaN	0	1	0.000015
2	Creditor 1	0.00	538.57	538.57	4.22	Other	PAID_IN_FULL	N	N	N	5.37	1.0	NaN	1	1	0.000020
3	Creditor 2	8279.50	8279.50	8279.50	4.22	Other	PASSIVE	Y	N	N	NaN	1.0	NaN	1	1	0.000015
4	Creditor 1	0.00	523.00	523.00	4.22	Other	PAID_IN_FULL	Y	N	Y	5.00	1.0	46.0	2	1	0.000020
5	Creditor 1	1118.74	790.30	790.30	4.22	Other	PASSIVE	Y	N	Y	10.00	1.0	NaN	0	1	0.000020
6	Creditor 1	0.00	71.89	71.89	4.22	Other	PAID_IN_FULL	N	N	Y	91.27	1.0	50.0	2	1	0.000020
7	Creditor 2	0.00	11091.35	11091.35	4.22	Other	PAID_IN_FULL	N	N	Y	1200.00	1.0	NaN	1	1	0.000015
8	Creditor 1	481.34	404.67	404.67	4.22	Other	CLOSED	Y	N	N	20.00	1.0	NaN	1	0	0.000020
9	Creditor 1	0.00	903.76	903.76	4.22	Other	PAID_IN_FULL	N	N	Y	8.26	1.0	46.0	1	1	0.000020

	OriginalCreditor_Redacted	CurrentBalance	DebtLoadPrincipal	BalanceAtDebtLoad	PurchasePrice	ProductOrDebtType	CollectionStatus	IsStatBarred	InBankruptcy	IsLegal	LastPaymentAmount	NumLiableParties	CustomerAge	NumPhones	NumEmails	NumAddresses	FrequencyEncodedCreditor
406413	Creditor 50	595.76	595.76	595.76	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	49.0	1	1	1	0.032577
406414	Creditor 50	1749.52	1749.52	1749.52	7.38	Finance Company - Other	UNDER_ARRANGEMENT	N	N	N	NaN	1.0	40.0	2	1	1	0.032577
406415	Creditor 50	4221.23	4221.23	4221.23	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	59.0	1	1	1	0.032577
406416	Creditor 50	1386.81	1386.81	1386.81	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	38.0	2	1	1	0.032577
406417	Creditor 50	8246.72	8246.72	8246.72	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	34.0	1	1	1	0.032577
406418	Creditor 50	448.20	448.20	448.20	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	36.0	1	1	1	0.032577
406419	Creditor 50	1678.37	1678.37	1678.37	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	37.0	0	1	1	0.032577
406420	Creditor 50	3512.60	3512.60	3512.60	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	71.0	1	1	1	0.032577
406421	Creditor 50	4477.31	4477.31	4477.31	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	38.0	1	1	1	0.032577
406422	Creditor 50	272.59	272.59	272.59	7.38	Finance Company - Other	ACTIVE	N	N	N	NaN	1.0	30.0	0	1	1	0.032577

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Connector Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample